package com.yss.kettle.domain;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.yss.common.core.annotation.EasyExcel;
import com.yss.common.core.utils.easyexecl.IntegerConverter;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;
import com.yss.common.core.web.domain.BaseEntity;

/**
 * ETL数据源信息对象 kettle_job_datasource
 *
 * @author yss
 * @date 2023-04-23
 */
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName("kettle_job_datasource" )
public class JobDatasource extends BaseEntity {

    /**
     * 主键
     */
    @ExcelIgnore
    @TableId("ID" )
    private String id;

    /**
     * 用户名
     */
    @ExcelProperty(value = "用户名" )
    @TableField("USERNAME" )
    private String username;

    /**
     * 密码
     */
    @ExcelProperty(value = "密码" )
    @TableField("PASSWORD" )
    private String password;

    /**
     * IP地址
     */
    @ExcelProperty(value = "IP地址" )
    @TableField("DBHOST" )
    private String dbhost;

    /**
     * 数据库名称
     */
    @ExcelProperty(value = "数据库名称" )
    @TableField("DBNAME" )
    private String dbname;

    /**
     * 端口号
     */
    @ExcelProperty(value = "端口号" )
    @TableField("DBPORT" )
    private String dbport;

    /**
     * 地址
     */
    @ExcelProperty(value = "地址" )
    @TableField("URL" )
    private String url;

    /**
     * 驱动
     */
    @ExcelProperty(value = "驱动" )
    @TableField("DRIVER_CLASS_NAME" )
    private String driverClassName;

    /**
     * 名称
     */
    @ExcelProperty(value = "名称" )
    @TableField("NAME" )
    private String name;

    /**
     * 类型
     */
    @ExcelProperty(value = "类型" )
    @TableField("FTYPE" )
    private String ftype;

    /**
     * 状态
     */
    @ExcelProperty(value = "状态", converter = IntegerConverter.class)
    @EasyExcel(readConverterExp = "1=正常,2=停用")
    @TableField("STATUS" )
    private Integer status;

}
